/*
 Navicat Premium Data Transfer

 Source Server         : stackcoding
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : car-dumper

 Target Server Type    : MySQL
 Target Server Version : 80020
 File Encoding         : 65001

 Date: 19/08/2021 16:04:19
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cardumper_alert
-- ----------------------------
DROP TABLE IF EXISTS `cardumper_alert`;
CREATE TABLE `cardumper_alert` (
  `id` varchar(255) NOT NULL COMMENT '设备编号',
  `type` varchar(255) DEFAULT NULL COMMENT '报警类型',
  `bjxx` varchar(255) DEFAULT NULL COMMENT '报警信息',
  `sjsj` varchar(255) DEFAULT NULL COMMENT '报警时间',
  `datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cardumper_alert
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cardumper_equipment
-- ----------------------------
DROP TABLE IF EXISTS `cardumper_equipment`;
CREATE TABLE `cardumper_equipment` (
  `id` varchar(255) NOT NULL COMMENT '设备编号',
  `equipment_name` varchar(255) DEFAULT NULL COMMENT '设备名称',
  `statu` int DEFAULT NULL COMMENT '设备启用状态',
  `equipment_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '设备描述',
  `datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cardumper_equipment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cardumper_monitor
-- ----------------------------
DROP TABLE IF EXISTS `cardumper_monitor`;
CREATE TABLE `cardumper_monitor` (
  `id` varchar(255) NOT NULL COMMENT '设备编号',
  `dgzt` varchar(255) DEFAULT NULL COMMENT '对轨状态',
  `yczt` varchar(255) DEFAULT NULL COMMENT '压车状态',
  `ggzt` varchar(255) DEFAULT NULL COMMENT '挂钩状态',
  `dgjgxh` varchar(255) DEFAULT NULL COMMENT '对轨激光信号',
  `ycbxh1` varchar(255) DEFAULT NULL COMMENT '压车臂1#信号',
  `ycbxh2` varchar(255) DEFAULT NULL COMMENT '压车臂2#信号',
  `ycbxh3` varchar(255) DEFAULT NULL COMMENT '压车臂3#信号',
  `ycbxh4` varchar(255) DEFAULT NULL COMMENT '压车臂4#信号',
  `aisbxh` varchar(255) DEFAULT NULL COMMENT 'AI识别信号',
  `fzjd` varchar(255) DEFAULT NULL COMMENT '翻转角度',
  `sjsj` varchar(255) DEFAULT NULL COMMENT '数据时间',
  `datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cardumper_monitor
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cardumper_pro
-- ----------------------------
DROP TABLE IF EXISTS `cardumper_pro`;
CREATE TABLE `cardumper_pro` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '项目id',
  `pro_name` varchar(255) DEFAULT NULL COMMENT '项目名称',
  `pro_info` varchar(255) DEFAULT NULL COMMENT '项目简介',
  `pro_addr` varchar(255) DEFAULT NULL COMMENT '项目所在地',
  `pro_lead` varchar(255) DEFAULT NULL COMMENT '项目负责人',
  `lead_tel` varchar(255) DEFAULT NULL COMMENT '负责人电话',
  `statu` int DEFAULT NULL COMMENT '项目是否启动',
  `datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cardumper_pro
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cardumper_pro_equ_ref
-- ----------------------------
DROP TABLE IF EXISTS `cardumper_pro_equ_ref`;
CREATE TABLE `cardumper_pro_equ_ref` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pro_id` int DEFAULT NULL,
  `equ_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cardumper_pro_equ_ref
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cardumper_user
-- ----------------------------
DROP TABLE IF EXISTS `cardumper_user`;
CREATE TABLE `cardumper_user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `account` varchar(255) NOT NULL COMMENT '账号',
  `password` varchar(255) NOT NULL COMMENT '密码',
  `nick_name` varchar(255) DEFAULT NULL COMMENT '昵称',
  `age` int DEFAULT NULL COMMENT '0女1男',
  `tel` varchar(255) DEFAULT NULL COMMENT '手机号',
  `is_deleted` int DEFAULT NULL COMMENT '删除标记',
  `datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cardumper_user
-- ----------------------------
BEGIN;
INSERT INTO `cardumper_user` VALUES (1, 'admin', '123456', '系统管理员', NULL, NULL, NULL, '2021-08-19 15:59:43');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
